UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q8nFSpIJf4MBtbgrJDhs3IcuNEEwBVsZ1DcgLkQZ/rg='
WHERE
key_id = '9b9925c25275c4661272c68d00bb782e31fe65526986dea04b05aa6d62993512'
AND (
token = 'q8nFSpIJf4MBtbgrJDhs3IcuNEEwBVsZ1DcgLkQZ/rg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)