UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7YWH4EdCddSPtBX3wpWbWpSr7p8LKZRb+F7d1r8oFcs='
WHERE
key_id = 'b8a26ad2a981d1c3982add5771f3f5be780b10078c572c9dc8e6324c05d77878'
AND (
token = '7YWH4EdCddSPtBX3wpWbWpSr7p8LKZRb+F7d1r8oFcs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)