UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bK1BOaMAOfTxzmh4hY34Hyz7iS8c5Ss6vPufT639m8U='
WHERE
key_id = '4827bc48b142f26cde9b99e2e117f24b6ff29f00070bc5ca0477f296ce5121ce'
AND (
token = 'bK1BOaMAOfTxzmh4hY34Hyz7iS8c5Ss6vPufT639m8U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)