UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H8V3MqwVqS9IDMY6oUnfN4yW/nJa5Zyzus0Xo+1KLZQ='
WHERE
key_id = 'fad8f52198b7d605f587e5dcf59822b96af5e645ff4695e0843993823c8a74e7'
AND (
token = 'H8V3MqwVqS9IDMY6oUnfN4yW/nJa5Zyzus0Xo+1KLZQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)