UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lPb1FqeHLOlUOHthrWvt28l60iUiYNKLQZ9xFD8ouhM='
WHERE
key_id = '472a3f5478344a610c6e1d98b80016ea78c20f31de0d539e67abe243b3a27d02'
AND (
token = 'lPb1FqeHLOlUOHthrWvt28l60iUiYNKLQZ9xFD8ouhM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)