UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bOA9akitYczs3X+1UB5imVnc8r3aq54k1ZtVYaGjfro='
WHERE
key_id = '28b8e0c27bef7c441c9b30338e6a79df2e9f64656ad431b681c800c716ba9197'
AND (
token = 'bOA9akitYczs3X+1UB5imVnc8r3aq54k1ZtVYaGjfro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)