UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b9QewzASHwNuJcDcX7i07eRGsl0t6D/kZF/F1AJC4/8='
WHERE
key_id = '6bae8bf4b3a48c0c0e7c59a95e1179066595a1c2a78aa2b88bbe5c6365d54bc0'
AND (
token = 'b9QewzASHwNuJcDcX7i07eRGsl0t6D/kZF/F1AJC4/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)