UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2EM7F/mzCrnp7irGRBJrUC3z7txzUiGdbGDhO0mkq6Y='
WHERE
key_id = '6cfa9a83ed5c7b378d1cfd60186da1c611c8f645e26cdac5445654eb412a30ee'
AND (
token = '2EM7F/mzCrnp7irGRBJrUC3z7txzUiGdbGDhO0mkq6Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)