UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '916bh9dtf9hNNINsZ9aIFSOLqRk3q0RHLrYqv9L+VSs='
WHERE
key_id = '12de1b0f9abec4897b7fafee3a8445b0284ed5c695f0ed69656b5c975de7239c'
AND (
token = '916bh9dtf9hNNINsZ9aIFSOLqRk3q0RHLrYqv9L+VSs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)