UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N9P9RFdJCRkKIEw5IrWzqNwppuGJayPLNKGzbeKQYiA='
WHERE
key_id = 'e0d37e08c99c69c5b3dea7e9a796d65e25e64e3f8e9a45ae6a9063b5d47c4284'
AND (
token = 'N9P9RFdJCRkKIEw5IrWzqNwppuGJayPLNKGzbeKQYiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)