UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k2AdKD3pUkyYnyW2SfMdE39MVJSq6lrrt3xrvKUq6GE='
WHERE
key_id = '31fa66e23e798f964d9774acebdc9dd174bb10117459638690a0542f8a1bd9a5'
AND (
token = 'k2AdKD3pUkyYnyW2SfMdE39MVJSq6lrrt3xrvKUq6GE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)