UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1PrCkWbVgZxHxEEnkL26uSsPI6TkwDfwHThvmUK2s6E='
WHERE
key_id = '52d0b6d31c8d87968ee694712f797930519ce585a73f60b2feaea0d558c34fbb'
AND (
token = '1PrCkWbVgZxHxEEnkL26uSsPI6TkwDfwHThvmUK2s6E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)