UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MYSiKq/P0NMy4ovANrtbT69WH32LUrWo9PjOYr0Lsr0='
WHERE
key_id = '5b1d1e5146f0f05f103089933c6c7a97cf20628d95529891aa01073a599598dc'
AND (
token = 'MYSiKq/P0NMy4ovANrtbT69WH32LUrWo9PjOYr0Lsr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)