UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C53ny+QErJG0+ukeRtXOFdce9cZjEMr5H/3JVJOJYIM='
WHERE
key_id = '0b47f24cd82c93eeafabb97a0107445f1e3b63d208e555bd8f9bd5da14364a82'
AND (
token = 'C53ny+QErJG0+ukeRtXOFdce9cZjEMr5H/3JVJOJYIM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)