UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oJ8xvTbrHSjYEy/ASltT/ZYGEDq61mbVOxcPIiMheBA='
WHERE
key_id = '81c1e6522c3969a92c138d39fe54d7fa06e7155a705a943a6b66e1a637c83054'
AND (
token = 'oJ8xvTbrHSjYEy/ASltT/ZYGEDq61mbVOxcPIiMheBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)