UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z1NKBG+i4yYiN8li9B5KmW849/Yvz4Hos5NqK++pxjI='
WHERE
key_id = '50c6038da292bf0aa9ca684c33563cac2369fa0c126a06b30e70343c34c049f6'
AND (
token = 'z1NKBG+i4yYiN8li9B5KmW849/Yvz4Hos5NqK++pxjI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)