UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '31h1nE5Ycht7vyBv6rb8QM0GdKQUCxl/zKtEAmlr5Yk='
WHERE
key_id = '7ece2b1c3eaa975bc1edd803222681ba93ea54f9b289cc5fb1b08a23f4ef2320'
AND (
token = '31h1nE5Ycht7vyBv6rb8QM0GdKQUCxl/zKtEAmlr5Yk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)