UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p+KZUJkHDdl5sHG0RRRT4mGNFdi1tK3ImE9TdPk+MCo='
WHERE
key_id = 'be8d831534cb5ad742d97104f860faad0269be69b84df0b443ecbcb204270acd'
AND (
token = 'p+KZUJkHDdl5sHG0RRRT4mGNFdi1tK3ImE9TdPk+MCo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)