UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IH13iCZtaU9uTtrYLhAoZ76a73Ay40EfE44OP7jgTtI='
WHERE
key_id = '38a9d4a96601c0df6a89e41793d864591934c7d337e285e1e450e28aead90cd2'
AND (
token = 'IH13iCZtaU9uTtrYLhAoZ76a73Ay40EfE44OP7jgTtI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)