UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WPC5/aFwlvxBCB71r9le2q0GmQbC8A4BfO6XuQlDYhw='
WHERE
key_id = 'bd9d62ed5214dcd314ccc20a607164a8a35390c2964f71f7142a5ac915396462'
AND (
token = 'WPC5/aFwlvxBCB71r9le2q0GmQbC8A4BfO6XuQlDYhw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)