UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k37Fn/3oYGHGJQlKiUg/i68QFh+lNsWfj3DleMYIslo='
WHERE
key_id = 'a391ab56c1111acb2d87c6bbb80b14ea6b005642e2d54b252f17a24acf07a65e'
AND (
token = 'k37Fn/3oYGHGJQlKiUg/i68QFh+lNsWfj3DleMYIslo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)