UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8hwph1aTYuzIgTdT8st+mQ+NY1BgK8RdzJj37sNvNCI='
WHERE
key_id = 'c6a24b2c745c817e9a36930a496c277300ae6556d81020220da6e4cbd58ef624'
AND (
token = '8hwph1aTYuzIgTdT8st+mQ+NY1BgK8RdzJj37sNvNCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)